IF OBJECT_ID('dbo.GetPCROAnalysisTypes') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.GetPCROAnalysisTypes
    IF OBJECT_ID('dbo.GetPCROAnalysisTypes') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.GetPCROAnalysisTypes >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.GetPCROAnalysisTypes >>>'
END
go
-- =======================================================================
-- Procedure Name: dbo.GetPCROAnalysisTypes
--
-- Author:      Kevin Cashman, Parallax Consulting LLC
--
-- Create date: 09/10/08
--
-- Description: Returns list of AnalysisType types for TurnAround Report
--
-- Parameters:  @DomainUserId 
--              
-- Returns:     INT, 0=Success, -1=Error
--
-- SampleCall:
-- EXECUTE dbo.GetPCROAnalysisTypes 11055
--
--------------------------------------------------------------------------
-- Date        Initials  Modification
--------------------------------------------------------------------------
-- 09/10/08    KC        Created
--
-- =======================================================================
CREATE PROCEDURE dbo.GetPCROAnalysisTypes
     (@DomainUserId                INT)
AS

     SET NOCOUNT ON 

     SELECT    1 AS Id,
               'Contract' AS AnalysisType
     UNION
     SELECT    2,
               'MCA'
     UNION
     SELECT    3,
               'Proposal'
     UNION
     SELECT    4,
               'WorkingBudget'
     ORDER BY Id                              


GO
IF OBJECT_ID('dbo.GetPCROAnalysisTypes') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.GetPCROAnalysisTypes >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.GetPCROAnalysisTypes >>>'
go


GRANT EXECUTE ON dbo.GetPCROAnalysisTypes TO InsightReport,Insight
go

